Tiny File Manager | customer_config_get

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: REEFTintegrationLog - get config data for customer id
//
// Programmer: AR
// Date      : 2025-05-27
//
//
// Copyright Reeft A/S (c) - 2025
//======================================================================================

//======================================================================================
// Set start time
//======================================================================================

$starttime = microtime(true);
	
//======================================================================================
// Get input
//======================================================================================

if (isset($_REQUEST["cust_number"])) {
		$input_cust_number = $_REQUEST["cust_number"];
	} else {
		$input_cust_number = '';
	}

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Get session variables
//======================================================================================
	include "include/getsession.php";
	include "include/sec2hms.php";
	include "include/REEFT_date_convert.php";

//======================================================================================
// Set language
//======================================================================================

include "include/set_language.php";

//======================================================================================
// Set defaults
//======================================================================================

$entries_found = 0;

$currentDate = date('Y-m-d');
	$currentTime = date('H:i:s');

$returnCode = '00';
	$returnMsg 	= 'Alles ist gut';

// Init
	$aryDetail = array();

header('Content-Type: application/json;charset=utf-8');

//======================================================================================
// Set database
//======================================================================================

//$db_name = 'customer/REEFT_integration.sqlite3';
	$db_name = $CUSTOMER_DATABASE_PATH;
	$DFT_SQLLITE_IP	= $db_name;

//======================================================================================
// Check if database file exists
//======================================================================================
	if (!file_exists($db_name)) {
		die(json_encode(['error' => "Database file '$db_name' does not exist."]));
	}

//======================================================================================
// Connect to some DB
//======================================================================================

include "include/db_connect.php";

//======================================================================================
// Init some fields
//======================================================================================

$pk_customer 	= 0;
		$cust_active 	= '';
		$cust_number 	= '';
		$cust_name 		= '';
		$cust_group 	= 0;

//======================================================================================
// Create SQL - active records
//======================================================================================
	$recordsTotalActive = 0;

$sql =  "SELECT * FROM reeft_customer WHERE cust_number = '$input_cust_number'";
	
	//echo $sql;
	
	include "include/db_run_sql.php";

foreach( $data as $row )
	{
		$pk_customer 							= $row["pk_customer"];
		$cust_active 							= $row["cust_active"];
		$cust_number 							= $row["cust_number"];
		$cust_name 								= $row["cust_name"];
		$cust_group 							= $row["cust_group"];
		$product	 							= $row["product"];
		$description	 						= $row["description"];
		$integration_version	 				= $row["integration_version"];
		$fileformat_ext_file	 				= $row["fileformat_ext_file"];
		$fileformat_exportterminationfile	 	= $row["fileformat_exportterminationfile"];
		$fileformat_numberdecimalseparator	 	= $row["fileformat_numberdecimalseparator"];
		$fileformat_separator	 				= $row["fileformat_separator"];
		$fileformat_codepage	 				= $row["fileformat_codepage"];
		$program_dir	 						= $row["program_dir"];
		$input_dir	 							= $row["input_dir"];
		$output_dir	 							= $row["output_dir"];
		$error_dir	 							= $row["error_dir"];
		$done_dir	 							= $row["done_dir"];
		$export_done_dir	 					= $row["export_done_dir"];
		$log_dir	 							= $row["log_dir"];
		$import_functions	 					= $row["import_functions"];
		$export_functions	 					= $row["export_functions"];
		$client_id	 							= $row["client_id"];
		$client_secret	 						= $row["client_secret"];
		$organizationId	 						= $row["organizationId"];
		$create_user	 						= $row["create_user"];
		$create_timestamp	 					= $row["create_timestamp"];
		$update_user	 						= $row["update_user"];
		$update_timestamp	 					= $row["update_timestamp"];
		$company_logo_url	 					= $row["company_logo_url"];
		$number_of_exports	 					= $row["number_of_exports"];
		$number_of_imports	 					= $row["number_of_imports"];
		$ERPname	 							= $row["ERPname"];
		$ERPdescription	 						= $row["ERPdescription"];
		$ERPurl	 								= $row["ERPurl"];
		$json_default_path	 					= $row["json_default_path"];
		$json_gps_default_path	 				= $row["json_gps_default_path"];
		$logseverity_customer	 				= $row["logseverity_customer"];
	}

//======================================================================================
// Customer exists
//======================================================================================

if ( $pk_customer > 0 ) {
		$customer_exists 	= 'Y';
		$returnCode    		= '00';
		$returnMsg 	   		= 'Customer does exists';
		$entries_found 		= 1;
	} else {
		$customer_exists 	= 'N';
		$returnCode 		= '99';
		$returnMsg 			= 'Customer does not exists';
		$entries_found 		= 0;
	}

//======================================================================================
// Calculate response time
//======================================================================================
	$endtime 			= microtime(true);
	$response_time 		= $endtime - $starttime;
	$response_time 		= number_format($response_time, 6, '.', '');
	$response_time_raw 	= number_format($response_time, 6, '.', '');
	$response_time 		= '(' . $response_time . ' seconds)';
	$response_time_raw 	= $response_time_raw;

//======================================================================================
// Create header
//======================================================================================
	$aryHeader = array();
	
	$aryHeader["entries_found"] 				= $entries_found;
	$aryHeader["returnCode"] 					= $returnCode;
	$aryHeader["returnMsg"] 					= $returnMsg;
	
	$aryHeader["currentDate"] 					= $currentDate;
	$aryHeader["currentTime"] 					= $currentTime;

$aryHeader["input_customer"] 				= $input_cust_number;
	$aryHeader["customer_exists"] 				= $customer_exists;
	$aryHeader["pk_customer"] 					= $pk_customer;
	$aryHeader["cust_active"] 					= $cust_active;
	$aryHeader["cust_number"] 					= $cust_number;
	$aryHeader["cust_name"] 					= $cust_name;
	$aryHeader["cust_group"] 					= $cust_group;
	
	$aryHeader["response_sec"] 					= $response_time;
	$aryHeader["response_sec_raw"] 				= $response_time_raw;

// Create array and prepare for json encoding
	$returnJson["header"] 						= $aryHeader;

//======================================================================================
// Paint it black
//======================================================================================
    echo(json_encode($returnJson));